Job Overview
We are seeking a highly skilled Lead Database Engineer to join our dynamic and innovative technology team in a fully remote capacity. This position offers the unique opportunity to work extensively with PostgreSQL databases, both on-premises and in cloud environments, while playing a pivotal role in maintaining our highly available, 24⁄7 SaaS platform. If you excel in a DevOps-oriented culture and possess a passion for leadership and mentorship, this role may be the ideal match for you.
Key Responsibilities
- Design, implement, and sustain critical PostgreSQL database systems essential for our 24⁄7 SaaS platform.
- Oversee data operations, ensuring practices around security, management, and usage adhere to industry best standards and align with organizational needs.
- Engage in project management and agile ceremonies, contributing to the successful delivery of robust solutions.
- Mentor and nurture team members, providing guidance on best practices in database design and optimization.
- Collaborate with cross-functional teams and stakeholders, ensuring effective communication and cooperation.
- Guarantee that database operations meet high availability, scalability, and recoverability standards.
- Conduct tuning and capacity management to satisfy performance requirements.
- Direct developers and engineers on database development, query optimization, and index management within a fully automated pipeline.
- Assist with development and testing, including setting up test data, automated testing scenarios, and refreshing development/testing environment data.
- Stay informed on emerging database technologies to enhance our database systems continuously.
- Ensure adherence to HIPAA security policies for all database-related activities.
- Provide on-call support for production databases and manage escalations as they arise.
Required Skills
- Expert understanding of RDBMS principles, database design, and normalization techniques.
- Extensive experience with PostgreSQL architecture, high-availability technologies, and performance tuning methodologies.
- Proficient in query optimization, indexing, materialized views, and partitioning.
- Strong command of PL/PgSQL, triggers, and stored procedure development in PostgreSQL.
- Familiarity with operating PostgreSQL in a Linux environment is essential.
- Experience with .NET clients that utilize PostgreSQL is an added advantage.
- Knowledge of cloud-based RDBMS solutions is beneficial.
- Understanding of agile development and DevOps principles is highly regarded.
Qualifications
- Bachelor's degree in Information Systems, Engineering, or a related discipline (or equivalent professional experience).
- 10+ years of experience in relational database administration.
- At least 3 years of hands-on experience with highly-available PostgreSQL databases.
Career Growth Opportunities
We are committed to your professional development and offer comprehensive training and mentorship programs to support your career advancement within the organization. Join us to expand your skills and explore new avenues for growth in a stimulating environment.
Company Culture and Values
Our organization prides itself on fostering a collaborative and innovative work environment that emphasizes teamwork and communication across departments. We uphold values of mentorship and continuous improvement, ensuring that every team member is equipped for success.
Compensation And Benefits
- Competitive salary range: \(110,000 - \)150,000 per year
- Comprehensive health, dental, vision, life, and disability insurance
- Retirement plan with company contributions
- Annual profit-sharing opportunities
- Professional development and training initiatives
- Structured onboarding and mentorship programs for your success
Join us and be part of a forward-thinking company that values expertise and fosters professional relationships.
Employment Type: Full-Time